/*
 Navicat Premium Data Transfer

 Source Server         : assassin
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 172.0.0.1:3306
 Source Schema         : assassin

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 30/05/2019 11:05:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for access
-- ----------------------------
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
  `access_id` varchar(38) NOT NULL,
  `product_id` varchar(38) NOT NULL,
  `parent_id` varchar(38) DEFAULT NULL COMMENT '父节点',
  `access_name` varchar(64) NOT NULL COMMENT '权限名称',
  `access_alias` varchar(64) NOT NULL COMMENT '权限别名',
  `access_type` char(1) NOT NULL COMMENT '权限种类（1-菜单，2-按钮，3-api）',
  `uri` varchar(256) DEFAULT NULL COMMENT '资源地址',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
  `icon` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`access_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限表';

-- ----------------------------
-- Records of access
-- ----------------------------
BEGIN;
INSERT INTO `access` VALUES ('0254c30267f9acfba49b5a71cfcbebbd', '893ab801-92c7-470c-bfac-77c4f2c54a25', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10', 'Assassin.button.edit', 'app_edit', '2', NULL, NULL, NULL, '2019-05-01 14:12:41', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('03550673b381fd7069a4d2d5d08aa393', '893ab801-92c7-470c-bfac-77c4f2c54a25', '03c3e591-2ed3-4474-9383-0f524f3d7dd9', 'Assassin.button.add', 'client_add', '2', NULL, NULL, NULL, '2019-04-27 06:35:32', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('03c3e591-2ed3-4474-9383-0f524f3d7dd9', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515', 'Assassin.menu.client', 'client', '1', '/system/client', NULL, NULL, '2019-04-08 03:06:29', '2019-05-16 06:14:10', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515', 'Assassin.menu.product', 'product', '1', '/system/product', NULL, NULL, '2019-04-08 02:57:07', '2019-05-16 06:24:10', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('0e2a7584489495e6332548b96222a16e', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'fea9fa4288c0387a8084c7b53ca2ddf0', 'Assassin.button.add', 'role_add', '2', NULL, NULL, NULL, '2019-05-01 16:08:11', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('139cfa390b4508bfe3f8b01bdfbf9aed', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2c315c600376e0820eefa6c93be114e8', 'Assassin.button.edit', 'tenant_edit', '2', NULL, NULL, NULL, '2019-05-01 16:20:34', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('16a05aee14629115832ae73e8809b4f5', '893ab801-92c7-470c-bfac-77c4f2c54a25', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', 'Assassin.button.delete', 'product_delete', '2', NULL, NULL, NULL, '2019-05-01 14:17:23', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('1929107c6a853059d9fa4d70989105a8', '893ab801-92c7-470c-bfac-77c4f2c54a25', '03c3e591-2ed3-4474-9383-0f524f3d7dd9', 'Assassin.button.edit', 'client_edit', '2', NULL, NULL, NULL, '2019-05-01 06:44:48', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('2aac8b4e-48ac-4e4f-8db0-43f41f90c515', '893ab801-92c7-470c-bfac-77c4f2c54a25', NULL, 'Assassin.menu.system', 'sysytem', '1', '/system', NULL, NULL, '2019-04-08 02:51:34', '2019-05-16 05:47:04', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('2c315c600376e0820eefa6c93be114e8', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'f8633292eb74e712d5fcdfb7129b68ef', 'Assassin.menu.tenant', 'tenant', '1', '/tenant/tenant', NULL, NULL, '2019-04-24 09:38:11', '2019-05-16 07:48:05', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('3013aab8b13a3e6557a8dcb8ae8d447b', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'fea9fa4288c0387a8084c7b53ca2ddf0', 'Assassin.button.roleAccess', 'role_access', '2', NULL, NULL, NULL, '2019-05-01 16:10:35', '2019-05-16 09:29:52', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('3586cd906316024c92ce1288ca6367b7', '893ab801-92c7-470c-bfac-77c4f2c54a25', '03c3e591-2ed3-4474-9383-0f524f3d7dd9', 'Assassin.button.delete', 'client_delete', '2', NULL, NULL, NULL, '2019-05-01 06:50:51', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('370f0f4d-194a-4948-8fed-dbd4dc4b9d10', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515', 'Assassin.menu.app', 'app', '1', '/system/app', NULL, NULL, '2019-04-08 03:07:08', '2019-05-16 06:24:46', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('38c97c19bb758d3a0d6089d16d12f026', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2c315c600376e0820eefa6c93be114e8', 'Assassin.button.tenantTemplate', 'tenant_template', '2', NULL, NULL, NULL, '2019-05-01 16:22:21', '2019-05-16 09:31:28', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('3a7980c26447eadde25104e8d4879877', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2c315c600376e0820eefa6c93be114e8', 'Assassin.button.view', 'tenant_view', '2', NULL, NULL, NULL, '2019-05-01 16:20:01', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('3ea06a0b85aa763a788636b9a9a0825f', '893ab801-92c7-470c-bfac-77c4f2c54a25', '56e82381263dc6dc46b9b7ab605ab1fb', 'Assassin.button.delete', 'user_delete', '2', NULL, NULL, NULL, '2019-05-01 15:53:13', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('4066ae5100c084284e35e447d9c1151e', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be', 'Assassin.button.delete', 'access_delete', '2', NULL, NULL, NULL, '2019-05-01 15:58:22', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('46226ccbe1ef99ccaf79452f7aa4e568', '893ab801-92c7-470c-bfac-77c4f2c54a25', '03c3e591-2ed3-4474-9383-0f524f3d7dd9', 'Assassin.button.view', 'client_view', '2', NULL, NULL, NULL, '2019-05-01 06:50:26', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('4642f620f05064ea322eea87b80e8495', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a02ed91a4dde50d07c7ee43ab86a563d', 'Assassin.button.add', 'template_add', '2', NULL, NULL, NULL, '2019-05-01 16:23:25', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('4bb59793d60084b6426204dbed817de2', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be', 'Assassin.button.edit', 'access_edit', '2', NULL, NULL, NULL, '2019-05-01 15:57:52', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('56e82381263dc6dc46b9b7ab605ab1fb', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a592c9fe-7b93-4cfe-bcce-d979ec375c4d', 'Assassin.menu.user', 'user', '1', '/rbac/user', NULL, NULL, '2019-04-09 10:48:28', '2019-05-16 06:27:52', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('5be6a6025526534b8934c4ee3489a7e0', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a02ed91a4dde50d07c7ee43ab86a563d', 'Assassin.button.templateAccess', 'template_access', '2', NULL, NULL, NULL, '2019-05-01 16:27:20', '2019-05-16 09:31:54', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('5d6e17f9e844c747676bd3df7d5efdc7', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2c315c600376e0820eefa6c93be114e8', 'Assassin.button.delete', 'tenant_delete', '2', NULL, NULL, NULL, '2019-05-01 16:21:21', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('5ecc0fef1801aa657d2c18589ce59d53', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'fea9fa4288c0387a8084c7b53ca2ddf0', 'Assassin.button.view', 'role_view', '2', NULL, NULL, NULL, '2019-05-01 16:08:37', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('633d1afe96dafa3d6caf28c3d18dbcd6', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'fea9fa4288c0387a8084c7b53ca2ddf0', 'Assassin.button.delete', 'role_delete', '2', NULL, NULL, NULL, '2019-05-01 16:09:47', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('6b6d5fbb6657e20741441b462b6d5bb2', '893ab801-92c7-470c-bfac-77c4f2c54a25', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10', 'Assassin.button.add', 'app_add', '2', NULL, NULL, NULL, '2019-05-01 14:12:18', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('711dcce00f41d8b032d8d15bd3b0cf5f', 'c3a4b5592602fc9e4d3f89a76c52f301', NULL, 'test1', 'test1', '3', NULL, NULL, NULL, '2019-05-27 08:25:27', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('73ab171b653e7e2cf95f5da839e2a648', 'c3a4b5592602fc9e4d3f89a76c52f301', NULL, 'test2', 'test2', '3', NULL, NULL, NULL, '2019-05-27 08:25:39', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('77aa33ca232596cc25801afff3671dd2', '893ab801-92c7-470c-bfac-77c4f2c54a25', '9a320e37-1be8-4ffb-b425-0cb36c781c2c', 'Assassin.button.delete', 'rule_delete', '2', NULL, NULL, NULL, '2019-05-01 15:44:30', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('77fa65260089437c017fae49dd913cca', '893ab801-92c7-470c-bfac-77c4f2c54a25', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', 'Assassin.button.productRule', 'product_rule', '2', NULL, NULL, NULL, '2019-05-01 14:18:30', '2019-05-16 09:29:02', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('80cebd9dc0b9dd886f794e42889c2c73', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a02ed91a4dde50d07c7ee43ab86a563d', 'Assassin.button.view', 'template_view', '2', NULL, NULL, NULL, '2019-05-01 16:23:54', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('8343ed73f73990a3947708c6a0d12487', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a02ed91a4dde50d07c7ee43ab86a563d', 'Assassin.button.edit', 'template_edit', '2', NULL, NULL, NULL, '2019-05-01 16:25:24', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('8568b70d19c23b525f639285144b367d', '893ab801-92c7-470c-bfac-77c4f2c54a25', '9a320e37-1be8-4ffb-b425-0cb36c781c2c', 'Assassin.button.add', 'rule_add', '2', NULL, NULL, NULL, '2019-05-01 15:43:45', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('88108f8187ce1df24b4cdb46cec88e66', '893ab801-92c7-470c-bfac-77c4f2c54a25', '56e82381263dc6dc46b9b7ab605ab1fb', 'Assassin.button.userRole', 'user_role', '2', NULL, NULL, NULL, '2019-05-01 15:53:48', '2019-05-16 09:29:30', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('8d94f6b72d5cb15fce4dc75900549b87', '893ab801-92c7-470c-bfac-77c4f2c54a25', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', 'Assassin.button.view', 'product_view', '2', NULL, NULL, NULL, '2019-04-10 04:31:46', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('92470b612017c870c0bb08a6056eddd1', '893ab801-92c7-470c-bfac-77c4f2c54a25', '56e82381263dc6dc46b9b7ab605ab1fb', 'Assassin.button.view', 'user_view', '2', NULL, NULL, NULL, '2019-05-01 15:52:30', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('930a697ee7252bd04883b5da08b5f321', '893ab801-92c7-470c-bfac-77c4f2c54a25', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10', 'Assassin.button.delete', 'app_delete', '2', NULL, NULL, NULL, '2019-05-01 14:13:14', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('941e337ba923c4507d9001a9f1130e41', '893ab801-92c7-470c-bfac-77c4f2c54a25', '56e82381263dc6dc46b9b7ab605ab1fb', 'Assassin.button.edit', 'user_edit', '2', NULL, NULL, NULL, '2019-05-01 15:52:52', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('94ada315c0736e3e748acb8d39a43ace', '893ab801-92c7-470c-bfac-77c4f2c54a25', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', 'Assassin.button.edit', 'product_edit', '2', NULL, NULL, NULL, '2019-04-10 04:30:40', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('94c47f4189bd7f4e62dbcec73da6cbdc', '893ab801-92c7-470c-bfac-77c4f2c54a25', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10', 'Assassin.button.view', 'app_view', '2', NULL, NULL, NULL, '2019-05-01 14:13:53', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('9a320e37-1be8-4ffb-b425-0cb36c781c2c', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515', 'Assassin.menu.tokenRule', 'rule', '1', '/system/tokenrule', NULL, NULL, '2019-04-08 03:08:56', '2019-05-16 06:25:13', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('a02ed91a4dde50d07c7ee43ab86a563d', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'f8633292eb74e712d5fcdfb7129b68ef', 'Assassin.menu.template', 'template', '1', '/tenant/template', NULL, NULL, '2019-04-24 09:38:38', '2019-05-16 07:48:23', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('a0c0583b13871f91fa0baf9a5ad2245f', '893ab801-92c7-470c-bfac-77c4f2c54a25', '2c315c600376e0820eefa6c93be114e8', 'Assassin.button.add', 'tenant_add', '2', NULL, NULL, NULL, '2019-05-01 16:18:53', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('a592c9fe-7b93-4cfe-bcce-d979ec375c4d', '893ab801-92c7-470c-bfac-77c4f2c54a25', NULL, 'Assassin.menu.rbac', 'rbac', '1', '/rbac', NULL, NULL, '2019-04-08 03:11:14', '2019-05-16 06:27:10', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('a8483ed4edb2a2053abf00ad12129002', '893ab801-92c7-470c-bfac-77c4f2c54a25', '9a320e37-1be8-4ffb-b425-0cb36c781c2c', 'Assassin.button.edit', 'rule_edit', '2', NULL, NULL, NULL, '2019-05-01 15:44:56', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('ab3070a4607409957a7aa3d0047dc5a5', '893ab801-92c7-470c-bfac-77c4f2c54a25', '56e82381263dc6dc46b9b7ab605ab1fb', 'Assassin.button.add', 'user_add', '2', NULL, NULL, NULL, '2019-05-01 15:52:07', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('c0c7a26143faeb6312ce9e2854dc6941', '893ab801-92c7-470c-bfac-77c4f2c54a25', '9a320e37-1be8-4ffb-b425-0cb36c781c2c', 'Assassin.button.view', 'rule_view', '2', NULL, NULL, NULL, '2019-05-01 15:44:07', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('cf3251ca43a79f4b5fc6a9faf223c2fa', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a02ed91a4dde50d07c7ee43ab86a563d', 'Assassin.button.delete', 'template_delete', '2', NULL, NULL, NULL, '2019-05-01 16:26:23', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('e94d0b7f095267bc8bb23c3b3c62e494', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be', 'Assassin.button.add', 'access_add', '2', NULL, NULL, NULL, '2019-05-01 15:57:08', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('ed247fd1-b6af-4df0-aa94-e3ae15aed0be', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a592c9fe-7b93-4cfe-bcce-d979ec375c4d', 'Assassin.menu.access', 'access', '1', '/rbac/access', NULL, NULL, '2019-04-08 03:11:54', '2019-05-16 06:28:07', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('f3c693e6de03116122138f3719228ff2', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be', 'Assassin.button.view', 'access_view', '2', NULL, NULL, NULL, '2019-05-01 15:57:32', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('f3e4b0db2d0cc83b63839a69ed763fe0', '9f6e665cde8cced9996c0bbb7860f217', NULL, 'test', 'test1', '3', NULL, NULL, NULL, '2019-05-27 07:13:49', '2019-05-27 07:19:45', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('f76f743fb346e02204ce115e104ca5fb', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'fea9fa4288c0387a8084c7b53ca2ddf0', 'Assassin.button.edit', 'role_edit', '2', NULL, NULL, NULL, '2019-05-01 16:08:59', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0', NULL);
INSERT INTO `access` VALUES ('f8633292eb74e712d5fcdfb7129b68ef', '893ab801-92c7-470c-bfac-77c4f2c54a25', NULL, 'Assassin.menu.mutliTenant', 'mutli_tenant', '1', '/tenant', NULL, NULL, '2019-04-24 09:37:20', '2019-05-16 07:46:31', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('fb71b5e1e215d3b08aad98ffdc420207', '893ab801-92c7-470c-bfac-77c4f2c54a25', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae', 'Assassin.button.add', 'product_add', '2', NULL, NULL, NULL, '2019-04-10 04:30:13', '2019-05-16 07:57:49', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
INSERT INTO `access` VALUES ('fea9fa4288c0387a8084c7b53ca2ddf0', '893ab801-92c7-470c-bfac-77c4f2c54a25', 'a592c9fe-7b93-4cfe-bcce-d979ec375c4d', 'Assassin.menu.role', 'role', '1', '/rbac/role', NULL, NULL, '2019-04-10 02:45:39', '2019-05-16 06:28:26', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for app
-- ----------------------------
DROP TABLE IF EXISTS `app`;
CREATE TABLE `app` (
  `app_id` varchar(38) NOT NULL COMMENT '主键ID',
  `app_name` varchar(64) NOT NULL COMMENT '微服务名称',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微服务';

-- ----------------------------
-- Records of app
-- ----------------------------
BEGIN;
INSERT INTO `app` VALUES ('0885fda9ee695c0c22ed103916ab3961', 'assassin-single-tenant-sample', 'Microservice of single-tenant', '2019-05-27 07:00:25', '2019-05-30 02:26:42', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0');
INSERT INTO `app` VALUES ('15345589998bac377c6fac3673dcb23c', 'assassin-mutli-tenant-sample', 'Microservice of mutli-tenant', '2019-05-27 08:23:04', '2019-05-30 02:26:46', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
INSERT INTO `app` VALUES ('9f2be5c8-a449-470a-bf64-89513bf0b8d7', 'assassin-console', 'Microservice of assassin', '2019-03-12 10:56:06', '2019-05-30 02:26:32', NULL, NULL, '0');
INSERT INTO `app` VALUES ('bad26b32288a1896c9885da58aa57e02', 'assassin-mutli-tenant-feign-sample', 'Microservice of Mutli-tenant', '2019-05-28 11:50:32', '2019-05-30 02:26:52', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(32) NOT NULL,
  `resource_ids` varchar(256) DEFAULT NULL,
  `client_secret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `authorized_grant_types` varchar(256) DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(256) DEFAULT NULL,
  `product_id` varchar(38) NOT NULL COMMENT '产品id',
  `token_rule_id` varchar(38) NOT NULL COMMENT '令牌规则id',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='oauth_client_details';

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('AssassinClientIdAndroid', NULL, 'AssassinClientSecretAndroid', 'all', 'password', NULL, NULL, NULL, NULL, NULL, NULL, '893ab801-92c7-470c-bfac-77c4f2c54a25', '34aa44b7-f697-41f7-be16-8696b47dde8a', 'Assassin 安卓端', '2019-04-03 15:44:25', '2019-05-30 02:34:49', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3');
INSERT INTO `oauth_client_details` VALUES ('AssassinClientIdIOS', NULL, 'AssassinClientSecretIOS', 'all', 'password', NULL, NULL, NULL, NULL, NULL, NULL, '893ab801-92c7-470c-bfac-77c4f2c54a25', '49b28658-4e2e-4c56-a6ba-0191af9f095f', 'Assassin IOS端', '2019-04-03 15:44:25', '2019-05-30 02:35:56', NULL, NULL);
INSERT INTO `oauth_client_details` VALUES ('AssassinClientIdWeb', '', 'AssassinClientSecretWeb', 'all', 'password', NULL, NULL, NULL, NULL, NULL, NULL, '893ab801-92c7-470c-bfac-77c4f2c54a25', '0bc7f2bc-eacb-4392-a60b-28ce864b506f', 'Assassin Web端', '2019-04-03 15:44:25', '2019-05-30 02:35:12', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3');
INSERT INTO `oauth_client_details` VALUES ('Mutli-TenantClientIdWeb', NULL, 'Mutli-TenantClientSecretWeb', 'all', 'refresh_token,password', NULL, NULL, NULL, NULL, NULL, NULL, 'c3a4b5592602fc9e4d3f89a76c52f301', '0bc7f2bc-eacb-4392-a60b-28ce864b506f', '多租户 Web端', '2019-05-27 08:24:59', '2019-05-30 02:35:31', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL);
INSERT INTO `oauth_client_details` VALUES ('Single-TenantClientIdWeb', NULL, 'Single-TenantClientSecretWeb', 'all', 'password,refresh_token', NULL, NULL, NULL, NULL, NULL, NULL, '9f6e665cde8cced9996c0bbb7860f217', '0bc7f2bc-eacb-4392-a60b-28ce864b506f', '内部应用 Web端', '2019-05-27 07:12:24', '2019-05-30 02:35:44', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL);
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `product_id` varchar(38) NOT NULL COMMENT '主键ID',
  `product_name` varchar(64) NOT NULL COMMENT '产品名称',
  `product_type` char(1) NOT NULL COMMENT '0-内部产品，1-多租户产品',
  `access_rule` char(1) DEFAULT '0' COMMENT '0-默认准入，1-角色准入，2-权限准入',
  `mutex_rules` varchar(1024) DEFAULT NULL COMMENT '令牌规则',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `avatar` varchar(512) DEFAULT NULL COMMENT '产品logo',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品';

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES ('893ab801-92c7-470c-bfac-77c4f2c54a25', 'Assassin', '0', '1', '[{\"rule\":\"assassinServerClientAndroid,assassinServerClientIos\"},{\"rule\":\"assassinServerClientAndroid,assassinServerClientWeb\"},{\"rule\":\"assassinServerClientIos,assassinServerClientWeb\"}]', 'Assassin-微服务下的企业产品权限安全脚手架', 'tmp_dd538175-78be-4bb7-8d7b-dec778201013.png', '2019-03-12 10:54:40', '2019-05-30 02:22:27', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
INSERT INTO `product` VALUES ('9f6e665cde8cced9996c0bbb7860f217', 'Single-tenant', '0', '0', NULL, 'Sample for single-tenant', '54bbd8a4f8674cf294864629c13a15fb.jpeg', '2019-05-27 07:11:04', '2019-05-27 07:11:27', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
INSERT INTO `product` VALUES ('c3a4b5592602fc9e4d3f89a76c52f301', 'Mutli-tenant', '1', '0', NULL, 'Sample for mutli-tenant', '2050bdcc4b8f44a38e7c3237294d21d4.jpeg', '2019-05-27 08:23:59', '2019-05-30 02:22:42', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
COMMIT;

-- ----------------------------
-- Table structure for product_app
-- ----------------------------
DROP TABLE IF EXISTS `product_app`;
CREATE TABLE `product_app` (
  `product_id` varchar(38) NOT NULL COMMENT '产品id',
  `app_id` varchar(38) NOT NULL COMMENT '微服务id',
  PRIMARY KEY (`product_id`,`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品微服务关联表';

-- ----------------------------
-- Records of product_app
-- ----------------------------
BEGIN;
INSERT INTO `product_app` VALUES ('893ab801-92c7-470c-bfac-77c4f2c54a25', '9f2be5c8-a449-470a-bf64-89513bf0b8d7');
INSERT INTO `product_app` VALUES ('9f6e665cde8cced9996c0bbb7860f217', '0885fda9ee695c0c22ed103916ab3961');
INSERT INTO `product_app` VALUES ('c3a4b5592602fc9e4d3f89a76c52f301', '15345589998bac377c6fac3673dcb23c');
INSERT INTO `product_app` VALUES ('c3a4b5592602fc9e4d3f89a76c52f301', 'bad26b32288a1896c9885da58aa57e02');
COMMIT;

-- ----------------------------
-- Table structure for product_template
-- ----------------------------
DROP TABLE IF EXISTS `product_template`;
CREATE TABLE `product_template` (
  `template_id` varchar(38) NOT NULL,
  `product_id` varchar(38) NOT NULL COMMENT '产品id',
  `template_name` varchar(64) NOT NULL COMMENT '模版名称',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品权限模版表';

-- ----------------------------
-- Records of product_template
-- ----------------------------
BEGIN;
INSERT INTO `product_template` VALUES ('a5f0fc4aef8af609881233b919a2a3ce', 'c3a4b5592602fc9e4d3f89a76c52f301', 'test', NULL, '2019-05-27 08:26:07', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` varchar(38) NOT NULL,
  `product_id` varchar(38) NOT NULL COMMENT '产品id',
  `tenant_id` varchar(38) DEFAULT NULL COMMENT '租户id',
  `role_name` varchar(64) NOT NULL COMMENT '角色名',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('17190f37fd087a7150affad66e5c1e3e', '893ab801-92c7-470c-bfac-77c4f2c54a25', NULL, '演示环境角色', '演示环境角色', '2019-04-15 02:34:34', '2019-05-08 06:40:19', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
INSERT INTO `role` VALUES ('a8e439f27d9816efc48eb1a6424e768e', 'c3a4b5592602fc9e4d3f89a76c52f301', '633be0f65bf7b5029ce077d4f496fca0', 'mutli-tenant-test1', NULL, '2019-05-27 09:04:32', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0');
INSERT INTO `role` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '893ab801-92c7-470c-bfac-77c4f2c54a25', NULL, '超级管理员', 'Assassin-console admin', '2019-03-18 11:35:01', '2019-05-30 02:39:04', NULL, NULL, '0');
INSERT INTO `role` VALUES ('f78e57d2b6afd3bc0622081f541f456b', '9f6e665cde8cced9996c0bbb7860f217', NULL, 'test', NULL, '2019-05-27 07:14:07', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for role_access
-- ----------------------------
DROP TABLE IF EXISTS `role_access`;
CREATE TABLE `role_access` (
  `role_id` varchar(38) NOT NULL COMMENT '角色id',
  `access_id` varchar(38) NOT NULL COMMENT '权限id',
  PRIMARY KEY (`role_id`,`access_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限关联表';

-- ----------------------------
-- Records of role_access
-- ----------------------------
BEGIN;
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '0254c30267f9acfba49b5a71cfcbebbd');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '03550673b381fd7069a4d2d5d08aa393');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '03c3e591-2ed3-4474-9383-0f524f3d7dd9');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '0e2a7584489495e6332548b96222a16e');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '139cfa390b4508bfe3f8b01bdfbf9aed');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '16a05aee14629115832ae73e8809b4f5');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '1929107c6a853059d9fa4d70989105a8');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '2c315c600376e0820eefa6c93be114e8');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '3013aab8b13a3e6557a8dcb8ae8d447b');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '3586cd906316024c92ce1288ca6367b7');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '38c97c19bb758d3a0d6089d16d12f026');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '3a7980c26447eadde25104e8d4879877');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '3ea06a0b85aa763a788636b9a9a0825f');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '4066ae5100c084284e35e447d9c1151e');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '46226ccbe1ef99ccaf79452f7aa4e568');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '4642f620f05064ea322eea87b80e8495');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '4bb59793d60084b6426204dbed817de2');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '56e82381263dc6dc46b9b7ab605ab1fb');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '5be6a6025526534b8934c4ee3489a7e0');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '5d6e17f9e844c747676bd3df7d5efdc7');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '5ecc0fef1801aa657d2c18589ce59d53');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '633d1afe96dafa3d6caf28c3d18dbcd6');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '6b6d5fbb6657e20741441b462b6d5bb2');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '77aa33ca232596cc25801afff3671dd2');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '77fa65260089437c017fae49dd913cca');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '80cebd9dc0b9dd886f794e42889c2c73');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '8343ed73f73990a3947708c6a0d12487');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '8568b70d19c23b525f639285144b367d');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '88108f8187ce1df24b4cdb46cec88e66');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '8d94f6b72d5cb15fce4dc75900549b87');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '92470b612017c870c0bb08a6056eddd1');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '930a697ee7252bd04883b5da08b5f321');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '941e337ba923c4507d9001a9f1130e41');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '94ada315c0736e3e748acb8d39a43ace');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '94c47f4189bd7f4e62dbcec73da6cbdc');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', '9a320e37-1be8-4ffb-b425-0cb36c781c2c');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'a02ed91a4dde50d07c7ee43ab86a563d');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'a0c0583b13871f91fa0baf9a5ad2245f');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'a592c9fe-7b93-4cfe-bcce-d979ec375c4d');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'a8483ed4edb2a2053abf00ad12129002');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'ab3070a4607409957a7aa3d0047dc5a5');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'c0c7a26143faeb6312ce9e2854dc6941');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'cf3251ca43a79f4b5fc6a9faf223c2fa');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'e94d0b7f095267bc8bb23c3b3c62e494');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'f3c693e6de03116122138f3719228ff2');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'f76f743fb346e02204ce115e104ca5fb');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'f8633292eb74e712d5fcdfb7129b68ef');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'fb71b5e1e215d3b08aad98ffdc420207');
INSERT INTO `role_access` VALUES ('17190f37fd087a7150affad66e5c1e3e', 'fea9fa4288c0387a8084c7b53ca2ddf0');
INSERT INTO `role_access` VALUES ('a8e439f27d9816efc48eb1a6424e768e', '711dcce00f41d8b032d8d15bd3b0cf5f');
INSERT INTO `role_access` VALUES ('a8e439f27d9816efc48eb1a6424e768e', '73ab171b653e7e2cf95f5da839e2a648');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '0254c30267f9acfba49b5a71cfcbebbd');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '03550673b381fd7069a4d2d5d08aa393');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '03c3e591-2ed3-4474-9383-0f524f3d7dd9');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '0a4e8dd8-10e0-43c0-99f1-fd54cea304ae');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '0e2a7584489495e6332548b96222a16e');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '139cfa390b4508bfe3f8b01bdfbf9aed');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '16a05aee14629115832ae73e8809b4f5');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '1929107c6a853059d9fa4d70989105a8');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '2aac8b4e-48ac-4e4f-8db0-43f41f90c515');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '2c315c600376e0820eefa6c93be114e8');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '3013aab8b13a3e6557a8dcb8ae8d447b');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '3586cd906316024c92ce1288ca6367b7');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '370f0f4d-194a-4948-8fed-dbd4dc4b9d10');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '38c97c19bb758d3a0d6089d16d12f026');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '3a7980c26447eadde25104e8d4879877');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '3ea06a0b85aa763a788636b9a9a0825f');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '4066ae5100c084284e35e447d9c1151e');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '46226ccbe1ef99ccaf79452f7aa4e568');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '4642f620f05064ea322eea87b80e8495');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '4bb59793d60084b6426204dbed817de2');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '56e82381263dc6dc46b9b7ab605ab1fb');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '5be6a6025526534b8934c4ee3489a7e0');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '5d6e17f9e844c747676bd3df7d5efdc7');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '5ecc0fef1801aa657d2c18589ce59d53');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '633d1afe96dafa3d6caf28c3d18dbcd6');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '6b6d5fbb6657e20741441b462b6d5bb2');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '77aa33ca232596cc25801afff3671dd2');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '77fa65260089437c017fae49dd913cca');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '80cebd9dc0b9dd886f794e42889c2c73');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '8343ed73f73990a3947708c6a0d12487');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '8568b70d19c23b525f639285144b367d');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '88108f8187ce1df24b4cdb46cec88e66');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '8d94f6b72d5cb15fce4dc75900549b87');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '92470b612017c870c0bb08a6056eddd1');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '930a697ee7252bd04883b5da08b5f321');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '941e337ba923c4507d9001a9f1130e41');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '94ada315c0736e3e748acb8d39a43ace');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '94c47f4189bd7f4e62dbcec73da6cbdc');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', '9a320e37-1be8-4ffb-b425-0cb36c781c2c');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'a02ed91a4dde50d07c7ee43ab86a563d');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'a0c0583b13871f91fa0baf9a5ad2245f');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'a592c9fe-7b93-4cfe-bcce-d979ec375c4d');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'a8483ed4edb2a2053abf00ad12129002');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'ab3070a4607409957a7aa3d0047dc5a5');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'c0c7a26143faeb6312ce9e2854dc6941');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'cf3251ca43a79f4b5fc6a9faf223c2fa');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'e94d0b7f095267bc8bb23c3b3c62e494');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'ed247fd1-b6af-4df0-aa94-e3ae15aed0be');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'f3c693e6de03116122138f3719228ff2');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'f76f743fb346e02204ce115e104ca5fb');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'f8633292eb74e712d5fcdfb7129b68ef');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'fb71b5e1e215d3b08aad98ffdc420207');
INSERT INTO `role_access` VALUES ('d8842ca1-1659-46eb-8fa8-a28555c6ed53', 'fea9fa4288c0387a8084c7b53ca2ddf0');
INSERT INTO `role_access` VALUES ('f78e57d2b6afd3bc0622081f541f456b', 'f3e4b0db2d0cc83b63839a69ed763fe0');
COMMIT;

-- ----------------------------
-- Table structure for template_access
-- ----------------------------
DROP TABLE IF EXISTS `template_access`;
CREATE TABLE `template_access` (
  `template_id` varchar(38) NOT NULL COMMENT '租户权限模版id',
  `access_id` varchar(38) NOT NULL COMMENT '权限id',
  PRIMARY KEY (`template_id`,`access_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='租户模版权限关联表';

-- ----------------------------
-- Records of template_access
-- ----------------------------
BEGIN;
INSERT INTO `template_access` VALUES ('a5f0fc4aef8af609881233b919a2a3ce', '711dcce00f41d8b032d8d15bd3b0cf5f');
INSERT INTO `template_access` VALUES ('a5f0fc4aef8af609881233b919a2a3ce', '73ab171b653e7e2cf95f5da839e2a648');
COMMIT;

-- ----------------------------
-- Table structure for tenant
-- ----------------------------
DROP TABLE IF EXISTS `tenant`;
CREATE TABLE `tenant` (
  `tenant_id` varchar(38) NOT NULL,
  `tenant_name` varchar(64) NOT NULL COMMENT '租户名称',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
  PRIMARY KEY (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='租户表';

-- ----------------------------
-- Records of tenant
-- ----------------------------
BEGIN;
INSERT INTO `tenant` VALUES ('633be0f65bf7b5029ce077d4f496fca0', 'mutli_tenant', NULL, '2019-05-27 08:26:28', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for tenant_template
-- ----------------------------
DROP TABLE IF EXISTS `tenant_template`;
CREATE TABLE `tenant_template` (
  `tenant_id` varchar(38) NOT NULL COMMENT '租户id',
  `template_id` varchar(38) NOT NULL COMMENT '模版id',
  PRIMARY KEY (`tenant_id`,`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='租户模版关联表';

-- ----------------------------
-- Records of tenant_template
-- ----------------------------
BEGIN;
INSERT INTO `tenant_template` VALUES ('633be0f65bf7b5029ce077d4f496fca0', 'a5f0fc4aef8af609881233b919a2a3ce');
COMMIT;

-- ----------------------------
-- Table structure for tenant_user
-- ----------------------------
DROP TABLE IF EXISTS `tenant_user`;
CREATE TABLE `tenant_user` (
  `tenant_id` varchar(38) NOT NULL COMMENT '租户id',
  `user_id` varchar(38) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`tenant_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='租户用户表';

-- ----------------------------
-- Records of tenant_user
-- ----------------------------
BEGIN;
INSERT INTO `tenant_user` VALUES ('633be0f65bf7b5029ce077d4f496fca0', 'b14a690e-ffe7-446f-8f65-bc70acc87ef3');
COMMIT;

-- ----------------------------
-- Table structure for token_rule
-- ----------------------------
DROP TABLE IF EXISTS `token_rule`;
CREATE TABLE `token_rule` (
  `rule_id` varchar(38) NOT NULL COMMENT '主键ID',
  `rule_name` varchar(64) NOT NULL COMMENT '规则名称',
  `rule_type` char(1) DEFAULT '0' COMMENT '0-指定时间点，1-指定时间',
  `token_validity` varchar(20) DEFAULT NULL COMMENT 'token有效时间',
  `refresh_token_validity` varchar(20) DEFAULT NULL COMMENT 'refreshToken有效时间',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user_id` varchar(38) DEFAULT NULL COMMENT '创建人用户id',
  `update_user_id` varchar(38) DEFAULT NULL COMMENT '修改人用户id',
  `del_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`rule_id`),
  KEY `token_rule_idx_rule_name` (`rule_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='令牌规则';

-- ----------------------------
-- Records of token_rule
-- ----------------------------
BEGIN;
INSERT INTO `token_rule` VALUES ('0bc7f2bc-eacb-4392-a60b-28ce864b506f', 'web', '0', '1,3,0,0', '7,3,0,0', 'web端规则', '2019-03-13 11:07:20', '2019-05-15 08:20:38', NULL, 'b14a690e-ffe7-446f-8f65-bc70acc87ef3', '0');
INSERT INTO `token_rule` VALUES ('34aa44b7-f697-41f7-be16-8696b47dde8a', 'android', '1', '5184000', NULL, '安卓端规则', '2019-03-14 11:37:54', '2019-04-03 01:00:40', NULL, NULL, '0');
INSERT INTO `token_rule` VALUES ('49b28658-4e2e-4c56-a6ba-0191af9f095f', 'ios', '1', '2592000', NULL, 'ios端规则', '2019-03-13 11:03:44', '2019-04-03 01:00:46', NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` varchar(38) NOT NULL COMMENT '主键ID',
  `account` varchar(64) NOT NULL COMMENT '帐号',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `nickname` varchar(24) DEFAULT NULL COMMENT '昵称',
  `mobile_phone_number` varchar(16) DEFAULT NULL COMMENT '移动电话号码',
  `wx_openid` varchar(32) DEFAULT '' COMMENT '微信 openid',
  `qq_openid` varchar(32) DEFAULT '' COMMENT 'QQ openid',
  `avatar` varchar(512) DEFAULT NULL COMMENT '头像',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `lock_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-锁定',
  `del_flag` char(1) DEFAULT '0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`user_id`),
  KEY `sys_user_idx_wx_openid` (`wx_openid`),
  KEY `sys_user_idx_qq_openid` (`qq_openid`),
  KEY `sys_user_idx_username` (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('a5468bfb6a283301de90b564f72d66b1', 'test', '$2a$10$1Cg32EdQU1iKksGYGdNuweOe/3Kumv6oQHRdh8fGbLJrc.T2bV9wW', '演示环境账号', '15000000001', '', '', '2a95ede25e9344c9bc8727ce7b554228.png', '2019-04-30 01:53:32', '2019-05-22 07:04:58', '0', '0');
INSERT INTO `user` VALUES ('b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'admin', '$2a$10$Nxhp2A17wqkZcd/YSUrzku4Jn9MXpA0FIE9OnsDPX6wIV.JC7pB5K', 'Barton Wu', '15000000000', '', '', '076fd1088f2e4c1ebe3453a974ceb9ce.JPG', '2019-03-03 20:34:23', '2019-05-30 02:43:40', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `user_id` varchar(38) NOT NULL COMMENT '用户id',
  `role_id` varchar(38) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色表';

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES ('a5468bfb6a283301de90b564f72d66b1', '17190f37fd087a7150affad66e5c1e3e');
INSERT INTO `user_role` VALUES ('b14a690e-ffe7-446f-8f65-bc70acc87ef3', '17190f37fd087a7150affad66e5c1e3e');
INSERT INTO `user_role` VALUES ('b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'a8e439f27d9816efc48eb1a6424e768e');
INSERT INTO `user_role` VALUES ('b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'd8842ca1-1659-46eb-8fa8-a28555c6ed53');
INSERT INTO `user_role` VALUES ('b14a690e-ffe7-446f-8f65-bc70acc87ef3', 'f78e57d2b6afd3bc0622081f541f456b');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
